How to: Print only what is selected.
Solution:
In query Datasheet view, select the records to be printed. 6) Select the 'File' menu and select 'Print...'.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Select the desired query. (The query is highlighted.)
4) Click 'Open'. (The query opens in Datasheet view.)
5) Select the records to be printed.
NOTE: Use the record selector to select records. Click on the first record and drag the mouse to the end of the desired record set.
Record selector
6) Select the 'File' menu and select 'Print...'. (The Print dialog box appears.)
7) Select the 'Selected Records' radio button in the 'Print Range' group.
Printing dialog box
8) Click 'OK'.
